<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

/*
* Excel library for Code Igniter applications
* Author: Derek Allard, Dark Horse Consulting, www.darkhorse.to, April 2006
*/

Class ExcelOut {

    public function to_excel($query='',$headers='', $filename='exceloutput')
    {
         $data = ''; // just creating the var for field data to append to below
         
         if (empty($query)) {
              echo '<p>The table appears to have no data.</p>';
         } else {
         
              foreach ($query as $row) {
                   $line = '';
                   foreach($row as $value) {                                            
                        if ((!isset($value)) OR ($value == "")) {
                             $value = "\t";
                        } else {
                             $value = str_replace('"', '""', $value);
                             $value = '"' . $value . '"' . "\t";
                        }
                        $line .= $value;
                   }
                   $data .= trim($line)."\n";
              }
              
              $data = str_replace("\r","",$data);
                             
              header("Content-type: application/x-msdownload");
              header("Content-Disposition: attachment; filename=$filename.xls");
              
              echo "$headers\n$data";  
         }
    }
}
?> 